/ Shareware Super Platinum 8 / Shareware Super Platinum 8.iso / mac / DATABASE / VLB352.ZIP;1 / QUERY.DSH

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 19 b2 0f 00 01 26 00 0b | 00 28 03 3f 3e 08 c4 bf |.....&..|.(.?>...|
|00000010| b3 d9 c4 c0 b3 da 01 05 | 46 69 65 6c 64 65 2f 20 |........|Fielde/ |
|00000020| 2f 20 2f 61 2f 73 2f 73 | 2f 69 2f 67 2f 6e 2f 65 |/ /a/s/s|/i/g/n/e|
|00000030| 2f 64 2f 20 2f 74 2f 6f | 2f 2e 2f 20 2f 20 2f 45 |/d/ /t/o|/./ / /E|
|00000040| 01 3f 02 01 26 43 6f 6e | 74 61 69 6e 73 20 74 68 |.?..&Con|tains th|
|00000050| 65 20 6e 61 6d 65 20 6f | 66 20 74 68 65 20 66 69 |e name o|f the fi|
|00000060| 65 6c 64 20 74 6f 20 74 | 65 73 74 01 3f 02 02 26 |eld to t|est.?..&|
|00000070| 74 68 65 20 71 75 65 72 | 79 20 61 67 61 69 6e 73 |the quer|y agains|
|00000080| 74 2e 20 20 50 72 65 73 | 73 20 45 4e 54 45 52 2f |t.  Pres|s ENTER/|
|00000090| 52 45 54 55 52 4e 01 3f | 02 03 18 74 6f 20 73 65 |RETURN.?|...to se|
|000000a0| 65 20 61 20 6c 69 73 74 | 20 6f 66 20 66 69 65 6c |e a list| of fiel|
|000000b0| 64 73 2e 00 02 03 00 03 | 00 4c 16 3f 3e 00 c4 bf |ds......|.L.?>...|
|000000c0| b3 d9 c4 c0 b3 da 01 08 | 4f 70 65 72 61 74 6f 72 |........|Operator|
|000000d0| 65 2f 20 2f 4e 2f 61 2f | 6d 2f 65 2f 20 2f 79 2f |e/ /N/a/|m/e/ /y/|
|000000e0| 6f 2f 75 2f 20 2f 77 2f | 69 2f 73 2f 68 2f 20 2f |o/u/ /w/|i/s/h/ /|
|000000f0| 01 3f 02 01 4a 45 6e 74 | 65 72 20 74 68 65 20 63 |.?..JEnt|er the c|
|00000100| 6f 6d 70 61 72 69 73 6f | 6e 20 6f 70 65 72 61 74 |ompariso|n operat|
|00000110| 6f 72 20 74 68 61 74 20 | 64 65 66 69 6e 65 73 20 |or that |defines |
|00000120| 68 6f 77 20 74 68 65 20 | 66 69 65 6c 64 20 6e 61 |how the |field na|
|00000130| 6d 65 20 65 6e 74 65 72 | 65 64 20 77 69 6c 6c 01 |me enter|ed will.|
|00000140| 3f 02 02 4a 62 65 20 63 | 6f 6d 70 61 72 65 64 20 |?..Jbe c|ompared |
|00000150| 77 69 74 68 20 74 68 65 | 20 73 65 61 72 63 68 20 |with the| search |
|00000160| 63 6f 6e 64 69 74 69 6f | 6e 20 64 65 66 69 6e 65 |conditio|n define|
|00000170| 64 2e 20 20 50 72 65 73 | 73 20 45 4e 54 45 52 2f |d.  Pres|s ENTER/|
|00000180| 52 45 54 55 52 4e 20 74 | 6f 20 6c 69 73 74 01 3f |RETURN t|o list.?|
|00000190| 02 03 1d 6f 70 65 72 61 | 74 6f 72 73 20 77 68 69 |...opera|tors whi|
|000001a0| 6c 65 20 69 6e 20 74 68 | 65 20 66 69 65 6c 64 2e |le in th|e field.|
|000001b0| 01 3f 02 05 3f 45 51 20 | 20 45 71 75 61 6c 20 54 |.?..?EQ | Equal T|
|000001c0| 6f 3a 20 53 65 61 72 63 | 68 65 73 20 66 6f 72 20 |o: Searc|hes for |
|000001d0| 61 6e 20 65 78 61 63 74 | 20 6d 61 74 63 68 20 28 |an exact| match (|
|000001e0| 6e 6f 74 20 63 61 73 65 | 20 73 65 6e 73 69 74 69 |not case| sensiti|
|000001f0| 76 65 29 2e 01 3f 02 07 | 44 47 54 20 20 47 72 65 |ve)..?..|DGT  Gre|
|00000200| 61 74 65 72 20 54 68 61 | 6e 3a 20 53 65 61 72 63 |ater Tha|n: Searc|
|00000210| 68 65 73 20 66 6f 72 20 | 72 65 63 6f 72 64 73 20 |hes for |records |
|00000220| 77 68 6f 73 65 20 73 65 | 61 72 63 68 20 66 69 65 |whose se|arch fie|
|00000230| 6c 64 20 63 6f 6e 74 61 | 69 6e 73 20 61 01 3f 06 |ld conta|ins a.?.|
|00000240| 08 24 76 61 6c 75 65 20 | 67 72 65 61 74 65 72 20 |.$value |greater |
|00000250| 74 68 61 6e 20 74 68 65 | 20 73 65 61 72 63 68 20 |than the| search |
|00000260| 76 61 6c 75 65 2e 01 3f | 02 0a 47 4c 54 20 20 4c |value..?|..GLT  L|
|00000270| 65 73 73 20 54 68 61 6e | 3a 20 53 65 61 72 63 68 |ess Than|: Search|
|00000280| 65 73 20 66 6f 72 20 72 | 65 63 6f 72 64 73 20 77 |es for r|ecords w|
|00000290| 68 6f 73 65 20 73 65 61 | 72 63 68 20 66 69 65 6c |hose sea|rch fiel|
|000002a0| 64 20 63 6f 6e 74 61 69 | 6e 73 20 61 20 76 61 6c |d contai|ns a val|
|000002b0| 75 65 01 3f 06 0b 1b 6c | 65 73 73 20 74 68 61 6e |ue.?...l|ess than|
|000002c0| 20 74 68 65 20 73 65 61 | 72 63 68 20 76 61 6c 75 | the sea|rch valu|
|000002d0| 65 2e 01 3f 02 0d 45 47 | 45 20 20 47 72 65 61 74 |e..?..EG|E  Great|
|000002e0| 65 72 20 54 68 61 6e 20 | 4f 72 20 45 71 75 61 6c |er Than |Or Equal|
|000002f0| 20 54 6f 3a 20 53 65 61 | 72 63 68 65 73 20 66 6f | To: Sea|rches fo|
|00000300| 72 20 72 65 63 6f 72 64 | 73 20 77 68 6f 73 65 20 |r record|s whose |
|00000310| 73 65 61 72 63 68 20 66 | 69 65 6c 64 01 3f 06 0e |search f|ield.?..|
|00000320| 3c 63 6f 6e 74 61 69 6e | 73 20 61 20 76 61 6c 75 |<contain|s a valu|
|00000330| 65 20 74 68 61 74 20 69 | 73 20 65 69 74 68 65 72 |e that i|s either|
|00000340| 20 67 72 65 61 74 65 72 | 20 74 68 61 6e 20 6f 72 | greater| than or|
|00000350| 20 65 71 75 61 6c 20 74 | 6f 20 74 68 65 01 3f 06 | equal t|o the.?.|
|00000360| 0f 0d 73 65 61 72 63 68 | 20 76 61 6c 75 65 2e 01 |..search| value..|
|00000370| 3f 02 11 42 4c 45 20 20 | 4c 65 73 73 20 54 68 61 |?..BLE  |Less Tha|
|00000380| 6e 20 4f 72 20 45 71 75 | 61 6c 20 54 6f 3a 20 53 |n Or Equ|al To: S|
|00000390| 65 61 72 63 68 65 73 20 | 66 6f 72 20 72 65 63 6f |earches |for reco|
|000003a0| 72 64 73 20 77 68 6f 73 | 65 20 73 65 61 72 63 68 |rds whos|e search|
|000003b0| 20 66 69 65 6c 64 01 3f | 06 12 47 63 6f 6e 74 61 | field.?|..Gconta|
|000003c0| 69 6e 73 20 61 20 76 61 | 6c 75 65 20 74 68 61 74 |ins a va|lue that|
|000003d0| 20 69 73 20 65 69 74 68 | 65 72 20 6c 65 73 73 20 | is eith|er less |
|000003e0| 74 68 61 6e 20 6f 72 20 | 65 71 75 61 6c 20 74 6f |than or |equal to|
|000003f0| 20 74 68 65 20 73 65 61 | 72 63 68 20 76 61 6c 75 | the sea|rch valu|
|00000400| 65 2e 01 3f 02 14 42 4e | 45 20 20 4e 6f 74 20 45 |e..?..BN|E  Not E|
|00000410| 71 75 61 6c 3a 20 53 65 | 61 72 63 68 65 73 20 66 |qual: Se|arches f|
|00000420| 6f 72 20 72 65 63 6f 72 | 64 73 20 6e 6f 74 20 65 |or recor|ds not e|
|00000430| 71 75 61 6c 20 74 6f 20 | 74 68 65 20 73 65 61 72 |qual to |the sear|
|00000440| 63 68 20 76 61 6c 75 65 | 2e 01 3f 02 16 45 43 54 |ch value|..?..ECT|
|00000450| 20 20 43 6f 6e 74 61 69 | 6e 65 64 3a 20 53 65 61 |  Contai|ned: Sea|
|00000460| 72 63 68 65 73 20 66 6f | 72 20 72 65 63 6f 72 64 |rches fo|r record|
|00000470| 73 20 74 68 61 74 20 63 | 6f 6e 74 61 69 6e 73 20 |s that c|ontains |
|00000480| 74 68 65 20 73 74 72 69 | 6e 67 20 65 6e 74 65 72 |the stri|ng enter|
|00000490| 65 64 2e 00 03 12 00 03 | 00 2d 03 3f 3e 08 c4 bf |ed......|.-.?>...|
|000004a0| b3 d9 c4 c0 b3 da 01 05 | 56 61 6c 75 65 69 2f 6e |........|Valuei/n|
|000004b0| 2f 20 2f 20 2f 61 2f 20 | 2f 20 2f 70 2f 61 2f 72 |/ / /a/ |/ /p/a/r|
|000004c0| 2f 74 2f 69 2f 63 2f 75 | 2f 6c 2f 61 2f 72 2f 20 |/t/i/c/u|/l/a/r/ |
|000004d0| 01 3f 02 01 2b 45 6e 74 | 65 72 20 74 68 65 20 76 |.?..+Ent|er the v|
|000004e0| 61 6c 75 65 20 66 6f 72 | 20 77 68 69 63 68 20 79 |alue for| which y|
|000004f0| 6f 75 20 77 61 6e 74 20 | 74 6f 20 63 68 65 63 6b |ou want |to check|
|00000500| 01 3f 02 02 2a 65 61 63 | 68 20 72 65 63 6f 72 64 |.?..*eac|h record|
|00000510| 20 61 67 61 69 6e 73 74 | 20 74 6f 20 73 65 65 20 | against| to see |
|00000520| 69 66 20 69 74 20 73 68 | 6f 75 6c 64 20 62 65 01 |if it sh|ould be.|
|00000530| 3f 02 03 09 73 65 6c 65 | 63 74 65 64 2e 00 04 11 |?...sele|cted....|
|00000540| 00 06 00 30 0d 3f 3e 08 | c4 bf b3 d9 c4 c0 b3 da |...0.?>.|........|
|00000550| 01 05 4c 6f 67 4f 70 00 | 00 00 00 00 07 00 06 00 |..LogOp.|........|
|00000560| 45 11 2a 09 01 00 63 82 | 00 00 64 82 36 07 06 07 |E.*...c.|..d.6...|
|00000570| 00 0b 00 f6 82 06 00 ae | 7b 00 01 3f 02 01 2c 45 |........|{..?..,E|
|00000580| 6e 74 65 72 20 41 4e 44 | 20 6f 72 20 4f 52 20 74 |nter AND| or OR t|
|00000590| 6f 20 73 70 65 63 69 66 | 79 20 68 6f 77 20 74 68 |o specif|y how th|
|000005a0| 65 20 63 6f 6e 64 69 74 | 69 6f 6e 01 3f 02 02 2a |e condit|ion.?..*|
|000005b0| 6f 6e 20 74 68 65 20 6e | 65 78 74 20 6c 69 6e 65 |on the n|ext line|
|000005c0| 20 73 68 6f 75 6c 64 20 | 62 65 20 6a 6f 69 6e 65 | should |be joine|
|000005d0| 64 20 77 69 74 68 20 74 | 68 65 01 3f 02 03 2c 70 |d with t|he.?..,p|
|000005e0| 72 65 63 65 64 69 6e 67 | 20 63 6f 6e 64 69 74 69 |receding| conditi|
|000005f0| 6f 6e 2e 20 20 45 6e 74 | 65 72 20 45 4e 44 20 69 |on.  Ent|er END i|
|00000600| 66 20 6e 6f 20 61 64 64 | 69 74 2d 01 3f 02 04 22 |f no add|it-.?.."|
|00000610| 69 6f 6e 61 6c 20 63 6f | 6d 70 61 72 69 73 69 6f |ional co|mparisio|
|00000620| 6e 73 20 61 72 65 20 74 | 6f 20 62 65 20 6d 61 64 |ns are t|o be mad|
|00000630| 65 2e 01 3f 02 06 2b 49 | 66 20 74 77 6f 20 63 6f |e..?..+I|f two co|
|00000640| 6e 64 69 74 69 6f 6e 73 | 20 61 72 65 20 6a 6f 69 |nditions| are joi|
|00000650| 6e 65 64 20 77 69 74 68 | 20 41 4e 44 2c 20 62 6f |ned with| AND, bo|
|00000660| 74 68 01 3f 02 07 2d 6d | 75 73 74 20 62 65 20 74 |th.?..-m|ust be t|
|00000670| 72 75 65 20 66 6f 72 20 | 61 20 72 65 63 6f 72 64 |rue for |a record|
|00000680| 20 74 6f 20 62 65 20 73 | 65 6c 65 63 74 65 64 2e | to be s|elected.|
|00000690| 20 20 49 66 01 3f 02 08 | 2c 74 77 6f 20 63 6f 6e |  If.?..|,two con|
|000006a0| 64 69 74 69 6f 6e 73 20 | 61 72 65 20 6a 6f 69 6e |ditions |are join|
|000006b0| 65 64 20 77 69 74 68 20 | 4f 52 2c 20 74 68 65 6e |ed with |OR, then|
|000006c0| 20 6f 6e 6c 79 01 3f 02 | 09 29 6f 6e 65 20 6e 65 | only.?.|.)one ne|
|000006d0| 65 64 73 20 74 6f 20 62 | 65 20 74 72 75 65 20 66 |eds to b|e true f|
|000006e0| 6f 72 20 74 68 65 20 72 | 65 63 6f 72 64 20 74 6f |or the r|ecord to|
|000006f0| 20 62 65 01 3f 02 0a 09 | 73 65 6c 65 63 74 65 64 | be.?...|selected|
|00000700| 2e 01 3f 02 0c 2c 54 77 | 6f 20 63 6f 6e 64 69 74 |..?..,Tw|o condit|
|00000710| 69 6f 6e 73 20 6a 6f 69 | 6e 65 64 20 74 6f 67 65 |ions joi|ned toge|
|00000720| 74 68 65 72 20 66 6f 72 | 6d 20 61 20 73 65 6c 65 |ther for|m a sele|
|00000730| 63 2d 01 3f 02 0d 0a 74 | 69 6f 6e 20 70 61 69 72 |c-.?...t|ion pair|
|00000740| 2e 00 05 0f 00 06 00 32 | 0d 3f 3e 08 c4 bf b3 d9 |.......2|.?>.....|
|00000750| c4 c0 b3 da 01 05 4c 6f | 67 4f 70 20 2f 68 2f 61 |......Lo|gOp /h/a|
|00000760| 2f 76 2f 65 2f 20 2f 74 | 2f 68 2f 65 2f 69 2f 72 |/v/e/ /t|/h/e/i/r|
|00000770| 2f 20 2f 66 2f 69 2f 72 | 2f 73 2f 74 2f 20 01 3f |/ /f/i/r|/s/t/ .?|
|00000780| 02 01 2c 54 68 65 20 6c | 6f 67 69 63 61 6c 20 6f |..,The l|ogical o|
|00000790| 70 65 72 61 74 6f 72 20 | 6f 6e 20 74 68 65 20 6c |perator |on the l|
|000007a0| 65 66 74 20 73 69 64 65 | 20 6f 66 20 74 68 65 01 |eft side| of the.|
|000007b0| 3f 02 02 2c 51 75 65 72 | 79 20 53 63 72 65 65 6e |?..,Quer|y Screen|
|000007c0| 20 69 73 20 75 73 65 64 | 20 74 6f 20 6a 69 6e 20 | is used| to jin |
|000007d0| 73 65 6c 65 63 74 69 6f | 6e 20 70 61 69 72 73 2e |selectio|n pairs.|
|000007e0| 01 3f 02 04 2f 45 6e 74 | 65 72 20 41 4e 44 20 6f |.?../Ent|er AND o|
|000007f0| 72 20 4f 52 20 74 6f 20 | 73 70 65 63 69 66 79 20 |r OR to |specify |
|00000800| 68 6f 77 20 74 68 65 20 | 70 72 65 76 69 6f 75 73 |how the |previous|
|00000810| 20 73 65 2d 01 3f 02 05 | 30 6c 65 63 74 69 6f 6e | se-.?..|0lection|
|00000820| 20 70 61 69 72 20 73 68 | 6f 75 6c 64 20 62 65 20 | pair sh|ould be |
|00000830| 6a 6f 69 6e 65 64 20 77 | 69 74 68 20 74 68 65 20 |joined w|ith the |
|00000840| 66 6f 6c 6c 6f 77 69 6e | 67 01 3f 02 06 2b 73 65 |followin|g.?..+se|
|00000850| 6c 65 63 74 69 6f 6e 20 | 70 61 69 72 2e 20 20 45 |lection |pair.  E|
|00000860| 6e 74 65 72 20 45 4e 44 | 20 69 66 20 6e 6f 20 61 |nter END| if no a|
|00000870| 64 64 69 74 69 6f 6e 61 | 6c 01 3f 02 07 1b 63 6f |dditiona|l.?...co|
|00000880| 6d 70 61 72 69 73 6f 6e | 73 20 61 72 65 20 74 6f |mparison|s are to|
|00000890| 20 62 65 20 6d 61 64 65 | 2e 01 3f 02 09 2f 49 66 | be made|..?../If|
|000008a0| 20 74 68 65 20 73 65 6c | 65 63 74 69 6f 6e 20 70 | the sel|ection p|
|000008b0| 61 69 72 73 20 61 72 65 | 20 6a 6f 69 6e 65 64 20 |airs are| joined |
|000008c0| 77 69 74 68 20 41 4e 44 | 20 74 68 65 6e 01 3f 02 |with AND| then.?.|
|000008d0| 0a 2e 62 6f 74 68 20 73 | 65 6c 65 63 74 69 6f 6e |..both s|election|
|000008e0| 20 70 61 69 72 73 20 6d | 75 73 74 20 65 76 61 6c | pairs m|ust eval|
|000008f0| 75 61 74 65 20 74 6f 20 | 74 72 75 65 20 66 6f 72 |uate to |true for|
|00000900| 01 3f 02 0b 2c 74 68 65 | 20 72 65 63 6f 72 64 20 |.?..,the| record |
|00000910| 74 6f 20 62 65 20 73 65 | 6c 65 63 74 65 64 2e 20 |to be se|lected. |
|00000920| 20 49 66 20 74 68 65 20 | 73 65 6c 65 63 74 69 6f | If the |selectio|
|00000930| 6e 01 3f 02 0c 2e 70 61 | 69 72 73 20 61 72 65 20 |n.?...pa|irs are |
|00000940| 6a 6f 69 6e 65 64 20 77 | 69 74 68 20 4f 52 2c 20 |joined w|ith OR, |
|00000950| 74 68 65 6e 20 6f 6e 6c | 79 20 6f 6e 65 20 73 65 |then onl|y one se|
|00000960| 6c 65 63 2d 01 3f 02 0d | 1b 74 69 6f 6e 20 70 61 |lec-.?..|.tion pa|
|00000970| 69 72 20 6e 65 65 64 73 | 20 74 6f 20 62 65 20 74 |ir needs| to be t|
|00000980| 72 75 65 2e 00          |                         |rue..   |        |
+--------+-------------------------+-------------------------+--------+--------+